Introduction

This document will cover the mappings for your monthly Inventory Journal postings.

Table of Contents

IN004 – PRODUCTION JOURNAL (GLAJM IPR)

This journal posts all production inventory transactions from the General Inventory (IN) module. This looks at the cost deck and the G/L setup, it credits those accounts and debits finished goods based on the ACT table. With this journal, you can select and format the report to see certain things and exclude others, make sure to remove any selections parameters prior to posting to the GL so that it posts everything and not just the few things selected.

DR Inventory – ACT table*

CR Components parts entered in Cost Deck (Menu INFMM Option CSC)

IN002 – COST OF SALES JOURNAL (GLAJM CSR)

This journal posts the cost of sales for wholesales sales from the Order Entry module but it is posted by inventory because OE causes inventory movements. With this journal, you can select and format the report to see certain things and exclude others, make sure to remove any selections parameters prior to posting to the GL so that it posts everything and not just the few things selected.

DR Expense from the MAX table (Maintain Financial-Code to G/L Account # ref (INFMM MAX)

CR Inventory – ACT table*

PS002 – POINT OF SALE COST OF SALES JOURNAL (GLAJM PCS)

This journal posts the cost of sales for all sales posted thru the Tasting Room and Consumer Sales (PS) module. With this journal, you can select and format the report to see certain things and exclude others, make sure to remove any selections parameters prior to posting to the GL so that it posts everything and not just the few things selected.

DR Expense from MCA table (PSFMM MCA)

CR Inventory – ACT table*

IN003 – TRANSFER JOURNAL (GLAJM ITR)

This journal posts the transfers between locations from the General Inventory (IN) module. This journal will post the tax consequences of moving wine from Bond to Tax paid depending on the Part Maser set-up of the Excise Tax Dollar control. It will also move the asset account from one account to another if the chart of accounts is set up with multiple cased goods accounts based on location (i.e. Library location). With this journal, you can select and format the report to see certain things and exclude others, make sure to remove any selections parameters prior to posting to the GL so that it posts everything and not just the few things selected.

DR Inventory – ACT table*

CR Inventory – ACT table*

IN005 – ADJUSTMENTS JOURNAL (GLAJM IAJ)

This journal posts the inventory loss/gain to the balance sheet based on the ACT table and the contra posts based on the MTX table. The MTX table is defined by the location code and the transaction code. With this journal, you can select and format the report to see certain things and exclude others, make sure to remove any selections parameters prior to posting to the GL so that it posts everything and not just the few things selected. (Note: This journal currently post receives also).

(sample shown as loss)

DR Expense acct from MTX table (INFMM MTX)

CR Inventory – ACT table*

* ACT table entry formats

I - _ _ - _ _ - _

1^st requirement is two-digit LOC code or ** for all locations

2^nd requirement is two-digit PFC code or ** for all PFC’s

3^rd requirement is one digit Journal Entry number or * for all JE’s

ETP/R -_ _ -_ _ -_ _

1st Requirement is ETP or ETR. ETP = Excise Tax Payable ETR = Excise Tax Refund

2nd Requirement is STATE or FED

3rd Requirement is LOC code or ** for all locations

4th Requirement is PFC code or ** for all PFC's

Browser not supported