This describes the rule updates required for the CREATE INVOICE and CREATE CREDIT NOTE functions, to accommodate the new Cost-of-Goods options for non-ROI items.
CREATE INVOICE
ERP Integration: Sage 300
If Order Details PACKAGE is blank/null, use fields from ORDER DETAILS table
If Order Details PACKAGE is not null, use fields from SALES PACKAGE DETAILS table
AR INVOICE entry
Insert 2 lines for each byondpro Order Detail
Description
GL Account Code
Amount
Tax Class
[ITEM CODE] + [ITEM DESCRIPTION]
GL Account COGS
Extended Cost * -1
3 (no tax)
[ITEM CODE] + [ITEM DESCRIPTION]
GL Account Expense/ Clearing
Extended Cost
3 (no tax)
INVOCARE specifically:
Above COGS entries are required as independent General Ledger journals, via the Compass integration logic.
This applies to INVOICE and CREDIT NOTE transactions.
Pre-Need Register
If pre-need conditions apply, then pass the following values to the Pre-Need data table (refer also PRE-NEED: INCLUDE COGS)
These field inserts apply to the same pre-need entry to be created for revenue entries.
Order Details Source
Pre-Need Entry
Extended Cost
Cost Amount
Item Number>Category
Pre-Need Entry
GL Account - Pre-Need COGS
GL Deffered Cost Account
GL Account - Cost of Good Sold
GL COGS Account
NOTE: GL segment over-ride rules apply, based on the Order Header/Site.
NEW CREDIT NOTE
When creating a NEW credit note, based on the source INVOICE number, populate following Order Details from corresponding invoice detail (package detail) line item. This follows the same conventions as Unit Price / Revenue GL Accounts:
- Unit Cost
- Extended Cost
- GL Account COGS
- GL Account Expense/Clearing
CREATE CREDIT NOTE
ERP Integration: Sage 300 - AR CREDIT NOTE entry
Insert 2 lines for each byondpro Order Detail
Description
GL Account Code
Amount
Tax Class
[ITEM CODE] + [ITEM DESCRIPTION]
GL Account COGS
Extended Cost
3 (no tax)
[ITEM CODE] + [ITEM DESCRIPTION]
GL Account Expense/ Clearing
Extended Cost * -1
3 (no tax)
PRE-NEED REGISTER: no action/change required - existing function will mark entries as redeemed
