Inventory/ Managing Unbilled Inventory

Inventory/ Managing Unbilled Inventory


    

Issuing Receive Order & Supplier’s Invoice With Different Costing

For the same Stock Items and quantities, Unbilled Inventory is a result of the difference in total value purchased, that you have earlier entered; in Receive Order compared to value of the actual Supplier Invoice.

Receiving Stock Items at $1000 each

Info
Location
Purchase> Receive Order
Info
Action
> Click PURCHASE activity
> Click RECEIVE ORDER module
> Click NEW
> VENDOR select (or create)
In-Time Supplier Pte Ltd
Details:
> ITEM select Dell Desktop
> QTY enter 3
> UNIT PRICE enter 1000
> AMOUNT check for 3,210
> Click ADD
> Close module

Enter the actual Supplier Invoice with Stock Items at $1050 each

> Click PURCHASE activity
> Click SUPPLIER INVOICE module
> Click NEW
> VENDOR select (or create)
In-Time Supplier Pte Ltd
> Click IMPORT
> Select RO.12/00000001
> Click ADD ALL ROWS
> Click BACK


Details:
> UNIT PRICE change to 1050
> Click ADD


Checking For Unbilled Inventory Amount



Info
Location
Report>Trial Balance
Info
Action
> Click REPORT activity
> Click FINANCIAL
> Click TRIAL BALANCE module
> Click REFRESH
> Unbilled Inventory Account check for $150

During receipt of goods, the items are cost at
$1000 x 3 = $3000.
However, the actual the Supplier Invoiced at $1050
$1050 x 3 = $3150
The is a difference of
$3150 - $3000 = $150.
The system automatically posts it to Unbilled Inventory
Account.

How do you Adjust Unbilled Inventory value

Info
Location
Adjustment> Unbilled Inventory
Info
Action
> Click ADJUSTMENT activity
> Click CLOSINGS
> Click UNBILLED INVENTORY module
> POSTING A/C select Stock Adjustment Select an account you would
like the unbilled inventory
amount to be adjusted to.
> Click STEP 1 GENERATE
> Click STEP 2 POST
> CONFIRM POST UNBILL click YES
> POST DONE click OK
> Close module

How can you avoid having values posted to Unbilled Inventory

NOTE: Since the Unbilled Inventory value happens when there is a difference between Receive Order and Supplier Invoice, you can amend the value of Receive Order to be the same as Supplier Invoice. Hence, Unbilled Inventory will have zero value.


Info
Location
Report> Trial Balance

Info
Action
> Click REPORT activity
> Click FINANCIAL
> Click TRIAL BALANCE module
> Click REFRESH
> STOCK ADJUSTMENT check for $150
> UNBILLED INVENTORY ACCOUNT
check for $0
> Close module





    • Related Articles

    • Inventory/ Understanding Stock Item Costing

      How Is Stock Item Costing Calculated? The system uses Weighted Average Cost as the method of calculating Ending Inventory cost. It takes Cost of Goods (Stock Items) available for Sales and divides it by the total quantities of the goods. This gives a ...

    • Inventory/ Stock Report / Financial Report

      Stock Report Location Report> Stock ActionClick REPORT activity > Click INVENTORY > Click STOCK module > Click REFRESH The report shows the latest stock status of all stock items. Note that you may enter at Filter to search for specific Lot No., ...

    • Inventory/ Stock Adjustment

      What Are Types Of Adjustment? Location Setup> Adjustment Type • Action Click SETUP activity > Click ITEM DETAILS > Click ADJUSTMENT TYPE module > Click NEW > TYPE select … > … NEW This is meant for you add new item in to the stock list. > … ...

    • Inventory/ Impact Of Deliveries On Stock

      Issuing A Delivery Order Location Sales> Delivery Order Action> Click SALES activity > Click DELIVERY ORDER module > Click NEW > CUSTOMER select EveryDay Customer Pte Ltd Details: > ITEM select Canon Laser Printer > QTY enter 8 > UNIT PRICE enter 300 ...

    • Inventory/ Periodic Versus Perpetual

      Periodic Inventory System Info Periodic inventory counts (such as once a month, or at the beginning and end of each year), and does not have an accurate record of the inventories in between these points This system does not keep continuous, ...