How to handle backdating COGS to be same date as the backdated Invoice

Overview

Shipments are usually the date the shipment is finalised.
However there is a way to back date a shipment to reflect the cost to be the same date as the back dated invoice.

Note: If you change the interface rule then this will apply for all shipments and invoices that you have applied the interface rule to.

What is Required:

Set up the Liability General Leger Account for the Provision for the COGS
Apply this to the Interface rules for each transaction type

Procedure

Step 1: Set up General ledger account to handle the Provision for the COGS on the shipment (Liability Account)
If you wish to differentiate between Sales and Service, you will need to set up two COGS provision accounts

Go to your chart of accounts and set up a general ledger account in the liability section eg 31020 'Provision for Accrued Sale Shipments'
You can also set up a number of general ledger accounts if you wish to break up the shipments for Sales, Service, Meter Charge runs etc.

Step 2: Amend the Interface Rules for Shipments (SALSHP) and corresponding Invoices (SALINV)

1. Log onto Readysell>Administration>Advanced>Interface rules
2. If you wish to break up shipments and invoices the transaction types for the interface rules that need to be amended are as follows:
   For Sales Invoices you need to adjust both the Salshp and Salinv 
   For Sales Credits/Returns you need to adjust both the Salret and Salcrd 
   For Service Invoices you need to adjust both the Srvshp and Srvinv
   For Meter Charge Invoices you need to adjust both the Salmcs and Salmci
   There maybe other interface rules for other transaction types if you use deposits on sale orders.

3. Within Interface Rules, search and find the shipment interface rule in the transaction type field = SALSHP (for shipments) and SALINV (is the invoice)

4. Apply the general ledger liability account that you created for 'provision for accrued shipments' to the cost line on this salshp interface rule.

   Debit to the Liability GL Account for the provision
   Credit to Stock on hand account
   See screen shot below

    Interface SALSHP Cost

   

   Now you need to apply the other side to the interface rule for the transaction type = SALINV for the Cost line 
   Add two lines for Cost affect
   Debit Cost of Goods 
   Credit Liability Provision for Accrued Shipments (account that you set up)
   See screen shot below

    Interface SALINV Cost

   

If you have changed the interface rule for the cost of goods for Sales Shipments, you need to also adjust the credit transaction type of Salret and Salcrd for when goods are returned
Still in Interface Rules
Search for transaction types = Salret and Salcrd
Salret interface rule, change the Debit to point to Provision Liability account

For the interface rule for transaction type = Salcrd , add two lines for the Cost affect
Credit Cost of Goods GL Liability Account 
Debit Cost of Goods GL account 
See screen shot below

For Service shipments and service invoices then do the same as above but for the transaction type of Srvshp and Srvinv. 
Firstly set up the General Ledger Liability Accounts for the Provision of the Service Shipments
Eg set up chart of account to stand for GL Account 32011 Provision for Accrued Service Shipments

Apply the interface rule to transaction types = Srvshp and Srvinv
See screen shots below

For Meter charge shipments and meter charge invoice then do the same as above but for the transaction type of Salmcs and Salmci