Navigation
Records in this category
- Location item status report and item status report
- Why does quantity balance in Stock Card Report does not tally with quantity on hand
- Location stock card report not tally with location item graded report
- User has sold a stock item but it does not appear in Stock Card Report
- Message prompted : Syntax error ,Ztoprin.preview.click, code 10
- Message prompted: Transaction File In Use, Please Try Again
- Printing invoice item code and service code not sort accordingly
- Message prompted : Table c:\ubsstk90\data\artran.dbf has become corrupted. code 2091.
- Message prompted : Memo file c:\ubsstk90\pt5\icbil#02.frt is missing or is invalid
- Maintain purchase price for credit note
- Maintain purchase price for credit note
- Why stock card report and location stock card report show difference transaction listing
- A103. Generate Stock Control Unit
- A104. Update Artran TOINV
- A106. Update Customer Recommended Price
- A107. Location Cost Of Good Sold Listing
- A101. Artran /Ictran Trancode Not Match
- A102. Combine Item
- View Gross Profit by Serial Number
- Generate the Stock Aging with year column
- The Periodic Transaction Report
- Set report format for cost allowed pin
- Customize the report to show that this invoice is printed before
- 2nd factor unit of measurement
- Maintain opening for Serial No Items
- Report customization (Invoice) for Odd/Even Item transaction with color display
- UBS Report to Microsoft Excel worksheet
- Display 3rd unit of measurement item
- Net Available Quantity
Tags
Sticky FAQs
UBS Inventory Software » Report
A107. Location Cost Of Good Sold Listing
Description
The solution below shows the steps to apply “AlO7. Location Cost Of Good Sold Listing” In Reports External Application. This feature provides you a full listing on how the system calculates cost of sales report by item location.
Solution
1. Create any location code eg. ‘HQ’.
2. Apply costing method ‘Moving Average’.
3. Transaction > Receive (HQ) with quantity 10, unit cost 15.
4. Transaction > Invoice (HQ) quantity sold for 2, selling price 30.
5. Go to Enquiry > Trace Item Cost & Value > Moving Average Method
6. Go to Sales Reports > Profit Margin > Calculate Cost Of Sales > Moving Average Method.
7. Go to Reports > Location Item Reports > Location — Item Status & Value
8. Go to Reports > External Application > Location Cost Of Good Sold Listing, tick “Create
Table Listat > DBF”, click “Yes“, tick “ALL TRANSACTIONS”, click “REFRESH“ button.
9. In COGS column , system shows 30 of cost of goods sold(Opening stock (0) + Purchase (150) + TR-IN + OAI — TR-OUT — OAR - Closing stock(120))
10. In IT_COS column, system shows 30 of cost of goods sold(Opening stock (0) + Purchase (150) — Closing stock(120))
11. Tick “Update Moving Cost From Unit Cost For Moving Cost=0” if Moving Average cost for opening stock contains zero, system will generate the latest cost from Item File Maintenance unit cost. You can view the effect in Edit Item Opening QuantityICost (Maintenance > Opening Quantity Maintenance)
Note: IT_COS may not be the same with COGS, opening stock for location will be developed in future.
TR-IN Transfer In; TR-OUT Transfer Out; OAI Adjustment Increase; OAR Adjustment
Reduce; Opening Opening Stock Value; Closing Closing Stock Value
Tags: A107. Location Cost Of Good Sold Listing
Related entries:
- General Ledger A/C Maintenance - View Ledger
- Difference between Only Credit Sales and Only Debit Cost Of Sales
- Voucher Footer Remark
- Page 1 of 1 instead of Page: 1
- Prompt unpaid bill listing
Author: Noor Diyana
Revision: 1.1
You cannot comment on this entry