We want to clear out our purchase accrual report of outdated Purchase Receipts and Purchase Receipt Returns that have no Bills or Debit Adjustments against them. We are creating Bills and Debit Adjustments using an import scenario for these outstanding lines, however, the unit cost on each line must be updated to 0. The documents will have a total of 0.00. That’s the tricky part, particularly for Debit Adjustments, because you don’t have the option on that screen to pull in purchase receipt lines one by one there, only entire purchase receipts, which brings in e.g. 6 lines at a time. How do you “go back” in an import scenario to update each line to 0, one by one? @@inventoryID is not a solution because in some cases, the same non-stock code is repeatedly used. I have attached the XML, also including some inactive lines where I tested doing this by Purchase Receipt Line (it works for Bills but not Debit Adj.).
Question
Import Scenario for Debit Adjustment with Purchase Receipt that later updates each line
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.