Date: Fri, 29 Mar 2024 06:10:03 +0000 (UTC) Message-ID: <935154541.107.1711692603589@f15897083cc6> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_106_699818326.1711692603588" ------=_Part_106_699818326.1711692603588 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
This article shows users how to make changes to the Cost of Goods Sold r= eport from an administrative perspective.
The COGS maintenance page serves as the single template for all stores' = Cost of Goods reporting in Decision Logic. This page is set up during the i= mplementation of your site. Users who are on Decision Logic=E2=80=99s newes= t V6 platform can view how to access and read their Cost of Goods Sold = Report by following this link.
Users who are currently on Decision Logic=E2=80=99s V5 system can view t= he Cost of Goods Sold Report by navigating to:
Reports > Cost and Variance > Cost of Goods Sold<= /p>
Select the Region, Group, and = Store.
Select the Year, Period, and W= eek.
Click Next.
View Detail
Category as Accounting Category
Category Section Totals
Cost of Goods Dollars
Beginning Inventory $ by Accounting Category
Purchases $ by Accounting Category
Ending Inventory % by Accounting Category
Usage $ =3D (Bi + P - Ei)
Percentage of Sales =3D Usage / Sales
Users can create "Accounting Categories" that will be used for each ingr= edient or inventoried items Account. Users will begin by navigating to:
Maintenance > Product > COGS Maintenance
Click the Accounting Categories tab.
Click New to add a new Accounting Category.
Click on an existing category and then= Edit to edit that category.
Click Save after entries are made.
Accounting Categories Details<= /span>
Enter Category #.
Category #s can be used for accounting exports like /wiki/spaces/= CST/pages/11206926.
Define the Name of the account.
Select the Section. This is the Category Section(s) cre= ated from the Category Section tab.
Select a PPC Account that each Accounting Category shou= ld use.
This is required for purchases to show up in the Cost of Goods sold repo= rt.
If a PPC Account does not exist, first make one under PPC Maintenance.
Define Accounting Method.
Market Value uses the last received price in the system for price extens= ions in the Cost of Goods Sold Report.
/wiki/spaces/CKBDA/pages/40566865, see /wiki/spaces/CKB= DA/pages/40566865ink for more information.
Enable Display Prices on Order Guides for each Accounti= ng Category.
Users can Enable Sort to move categories Up or Down in the list.
Users can create a Cost of Goods Sold report template by navigating to:<= /p>
Maintenance > Product > COGS Maintenance
Click the Category Sections tab.
Click New to add a new Category Section.
Click on an existing category section = and then Edit to edit that category.
Enter the information requested or made edits.
Click Save.
Category Sections Details
Create Category Sections.
Enable or Disable Show Category Section on Report.
Define sections Parent Sections.
Define the Sales Departments the report will use as a divisor when calcu= lating Usage on the Cost of Goods Report.
Define the Accounting Categories that each section will use when pulling= in purchases.
The COGS Rollup view will only show COGS Categories that include at= least one COGS Account which has been given a Department assignment in COG= S Maintenance.
Before setting up COGS Maintenance, it is best to ensure the following r= eferences are complete.
This will ensure you have all the required Accounts and Sales Department= s configured for reporting on your Cost of Goods Sold Report.
Sales Departments in POS Admin
PPC Accounts in/wiki/spaces/DCKBA/pages/9568542
If you are unsure how to re-design your Cost of Goods sold report, consu= lt with Decision Logic.
Moving PPC Accounts to new accounting categories requires a historical C= OGS and TvA update.
Below are some common reasons for changing COGS Maintenance.
=C2=A9 2023 Knowledge Management Systems, LLC. Decision Logic. All R= ights Reserved.
Table of Contents
For additional questions or assistance, please submit a support tic= ket by visiting the <= strong>Decision Logic Service Center.