Stock Variance Posting (Legacy)

Source: Nordics bundle documentation

Open

Open

Enable Plugin Implementation 

Go to Customization > Plug-Ins > Manage Plug-Ins and check the Finland Stock Variation Postings box. 

Configure the Plug-in Implementation

1. Go to Customizations > Plug-Ins > Plug-In Implementations. 

1. Click View next to Finland Stock Variation Postings. 

1. Click Configure: 

1. Custom GL Lines are run for the selected transaction types and subsidiaries. Below is the list of the supported types. 

• Item Receipt 

• Item Fulfillment (when created from Vendor Return Authorization) 

• Vendor Bill (stand-alone Bills) 

• Work Order Issue 

• Work Order Completion 

NOTE: Vendor Credit is not supported. Instead, use Vendor return Authorization to send the goods back to the supplier. 

Select the types you need to run the script on. 

If there are large amounts of lines/transactions, Asynchronous checkbox is strongly recommended since there is no need to do these postings in real time. 

Setting Chart of Accounts

Default accounts should be set for 3 different kind of postings: 

1. Default account for stock variations (usually finished products) 

1. WIP (and/or Raw material) value variation 

1. Default account to post purchases (expense account) 

Vendor Setup

In addition to default account settings, it is possible to set up the following: 

• On Vendor record, a vendor specific Purchase account to be used instead of CoA default. E.g. Vendor XY is an Intercompany Vendor and therefore will have its own Purchase account 

• On Inventory Asset account record, a specific Stock Variation Account to be used instead of CoA default. Use case: when you use two different asset accounts, e.g. Raw Materials and Finished Goods on items that you receive into inventory, and the stock value needs to be changed for both of these separately 

NOTE: Verify the installation and configuration by editing/creating at least one item receipt to validate the GL Impact 

1. Stock Variance Posting 

Upon saving a respective transaction, there is an additional posting made in the GL: 

DEBIT: expense account marked in COA as “Default Account for Purchases within Fiscal Year” or that on the Vendor record (the latter takes precedence). 

CREDIT (Item Receipt, Bill, Item Fulfillment): account marked in COA as “Default Account for Stock Variation Postings”, or that selected in “Stock Value Variation account” defined for the respective Inventory Asset account (the latter takes precedence). 

CREDIT (Work Order Issue, Work Order Completion): account marked in COA as “Default Account for WIP Variance”, or that selected in “Stock Value Variation account” defined for the respective Inventory Asset account (the latter takes precedence). 

Sivunvaihto 

From the below table you can see the mandatory postings of an inventory item from being received, used (can be skipped) and sold. The marked lines are generated through the Stock Value Variation script.