On the Purchase Header table, I've created two new fields: 1) "ISF_Sent" - Date - No Transfers 2) "ACCT_Code" - Lookup - 1 transfer (Purch. Inv. Header - Activated)
The issue is when I post the Purchase Order I get the following error message:
The following fields must have the same type:
Field: Acct Code <-- ISF Sent Date
Table: Purch. Inv. Header <-- Purchase Header
Type: Code <-- Date
I am confused because it looks like the ISF Sent Date is trying to be transferred and not the ACCT_Code field I created.
Attachments
1 Answers
That's because, in a few places, Microsoft tries to do automated field transfers based on field numbers alone. Use Personalization on the new fields list to show the Field No. field. Then make sure that the same field is numbered the same across different tables. Then it will work.
This resolved the issue. Thank you.
Please login or Register to submit your answer