Announcements
Dear D365 Experts,
I have tried recording a PO in our test environment with a total discount % then I use Calculate Total Discount on Purchase Fast tab. The PO Confirmation shows the correct net amount of the PO (orig. price less the total discount % that I entered). However upon perform Product Receipt, the vouchers still accounted for the original price (without considering/deducting the discount) Dr: Invty Cr: Purchase Accrual. Is there any parameter/flag that I missed ?
I have further tested a PO with Item Line discount and again uses the Multiline discount calculate option on Purchase Fast Tab. PO confirmation also reflects the correct net amount (orig price less the discount amount that I entered on PO line).
Same as issue on total discount %, the Product Receipt the entry still shows the original amount.
Please advise.
Thanks,
Pam
Hi Pam,
So, the issue was related to the charges on product receipt? If you have new requests, please create new questions on the forum.
Hi Andre,
Attached is the screen shot of one charge code that I setup & selected in Purchase Order. The cost did add up to the item cost. Thanks for your advice to enable 'Generate Charges on Product Receipt'.
I will just create another request coz I have more questions on Charges especially on the effect of Posting Type.
Thanks,
Pam
Hi Pam,
What exactly do you mean with 'RR'? Which of the scenarios is not working 1, 2 or both? What is the current behavior? What exactly did you show in the second screenshot? Have you enabled posting of charges during product receipt in the parameters?
Hi Andre,
Below is how I setup in 'Charges Code'. I'm not successful coz the financial entry during RR did not include the charge. I was hoping to achieve the following
Scenario 1: Custom duties to be accounted/added as part of item cost which will then be included on invoice of supplier.
Scenario 2: Freight charges to be accounted/added as part of item cost which will be billed separately by external courier company
Scenario 1: Custom duties of $3. Item cost $15
Debit: FG 18
Credit: Accrual 18
Debit Accrual 18
Credit: A/P 18
Scenario 2: Freight of $4. Item cost $15
Debit: FG 19
Credit: Accrual 19
Debit: Accrual 19
Credit: AP-supplier 15
Credit: AP-courier 4
or I can initially account it to Expense Clearing account
i.e. Incidental Purchase Cost then Allocate the total duties &/or Freight back to Inventory by performing certain process
Hi Pam,
Can you share how you did setup the charges? Is it accounting towards the item cost or did you specify a ledger account? Possibly add a screenshot with the charge settings?
Hi Andre,
Yes, I have the discount account setup in Item group-Purchase Order section and on GL-Accounts for Automatic Transactions-Vendor Cash Discount. I noticed that the system record the discount upon posting of Invoice. Why is it that the account used is the one in GL-Accounts for Automatic Transactions and not the one in Item Group? Is there a way to use the Discount GL in Item Group or if there is Discount GL in Vendor master record ? In what scenario will the Discount GL in Item Group be used ?
I now understand that Discount should not be accounted for as part of the item cost. Thanks for your reply.
I have another question - I would like to post incidental charges such as Freight, Custom duties to be absorbed by the item cost. I tried to use Charges on PO but upon Product Receipt & Invoice, the Charge amount that I linked & allocate to the item did not take effect. Can you also advise me on this as I may have missed something.
Thank you,
Pam
Why is it that item is still costed at gross price
Hi Pam,
Do you have ledger accounts setup in the posting profiles for discount? If so, the discount is calculated separately and will not be part of the item cost.
André Arnaud de Cal...
294,110
Super User 2025 Season 1
Martin Dráb
232,866
Most Valuable Professional
nmaenpaa
101,158
Moderator