Discount on Purchase Order

(0) Share

Report

Posted on by pams.basilio

425

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

Categories:

Financial Management

Supply Chain Management

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
pams.basilio 425 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No