Small and medium business | Business Central, N...

Posting Vendor Invoice for a Inventory Purchase Orders

(0) Share

Report

Posted on by Ctrail

Hi,

We are transitioning from prepayemnt to opening accounts.

Currenlty when we receive inventory we are opening the Purchase Order - Posting - Post - Receive and Invoice.

We now have suppliers with payment terms and I believe it is time to transition away from this receipting process.

Am I correct in thinking that the inventory should be carried out as Purchase Order - Posting - Post - Receive by the stores team and the accounting team should enter the invoice as Purchase Order - Posting - Post - Invoice and amend the Due Date to match when payment is due (unsure if this can be done automatically)?

All responses (5)

Answers (0)

Ctrail 38 on at

Like (0)

Report

Posting Vendor Invoice for a Inventory Purchase Orders

HI Yi Yong,

Thank you that clarifys those questions. I proposed your idea to my managmenet team and they have asked if our accounting team and preenter the invoices before the receipt. I have trialled it and I don't see how this is possible.
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Posting Vendor Invoice for a Inventory Purchase Orders

by default, the due date is calculated based on document date. if user needs it be based on posting date, user needs to make posting date same as document date.

this is somewhat confusing. Document is date is the date when the order is created. Many would expect the due date be based on the posting date. Unfortunately, this is not the out of box behavior of BC.

Jun Wang
Suggested answer

Yi Yong 1,391 Super User 2024 Season 2 on at

Like (1)

Report

Posting Vendor Invoice for a Inventory Purchase Orders

Hello,

The 'Due Date Calculation' is in the 'Payment Terms' table and not the vendor card.
Ctrail 38 on at

Like (0)

Report

Posting Vendor Invoice for a Inventory Purchase Orders

Hi @Yi Yong,

Thank you for your reply. I checked a vendor and I can see the Payment Terms but not the Due Date Calculation.

This is the Payments field from the Vendor screen that I can see. (I may not have access to it)
Suggested answer

Yi Yong 1,391 Super User 2024 Season 2 on at

Like (0)

Report

Posting Vendor Invoice for a Inventory Purchase Orders

Hello Ctrail,

If you have set up the 'Payment Terms' and 'Due Date Calculation', whenever the accounting team changes the 'Document Date' it will also update the 'Due Date'.

What you mentioned is correct.

The alternative and better approach will be using 'Get Receipt Lines' in the Purchase Invoice module.

You can look at the video here: How to get Posted Purchase Receipts into a Purchase Invoice - Dynamics 365 Business Central (usedynamics.com)

This method is for better segregation purposes.