Is there a way to have a payables invoice hit the GL on the date of the invoice instead of the date of the GRN? Is this a setting that can be changed?

Question

If the GRN date is later (which is always) than the invoice date, Sage 50 won't let me use the actual vendor invoice date. We usually get invoiced the day we order the material, but we never actually receive the material until later... 
 Example: 
 The vendor invoice is dated 2/27/2022 The items ordered were not received until 3/25/2022 
 When entering the payables invoice, Sage won't let me change the date to the actual invoice date-it gives me a message about the date entered must be the same as or later than the goods received note date 
 This makes my payables inaccurate as vendors go by the invoice date, but if we don't receive items until say a month later, Sage will only let me use the GRN date so then out payables due dates can greatly differ from the vendors due date and we end up being late on payments...

DeneshS · Accepted Answer

Hi STANFOS INC. , 
 The reason you are having this issue is because, the main purpose of Good Received Notes is to defer the expense (income statement) but not the inventory (asset). Because of GRN transaction and date limitations, you can try: 
 
 Create a Purchase Order dated 2/27/2022 and then convert the Purchase Order to Purchase Invoice dated 03/25/2022 or 
 Continue to use GRN but date it 2/27/2022 and when the items get delivered, you can convert it to Purchase Invoice dated 03/25/2022 
 
 The first option may be better for you as the GL is not touched when you do a Purchase Order. It only gets touched when you convert it to invoice. Hope this helps.

Sage 50 Canada

Is there a way to have a payables invoice hit the GL on the date of the invoice instead of the date of the GRN? Is this a setting that can be changed?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING