Item journal - Preview Posting in Business Central - video Dailymotion

Freelancer Madhavi

Agenda of the Video▶️: Preview item journals, and other related documents before posting.  Item Journal: This Document is used to Post the Inventory Adjustment Entries in many ways...  ▪️Take a Look: -  1️⃣Entry Type = Positive Adjustment, This is used for Posting Item Opening Entries (for example; 31st of July 2024 will become Opening Stock of 1st August (the Current Month) Inventories in Company's Main Store or Warehouse.  OR,  You may use it for Increasing Inventory-Item Values under Inventory Adjustment Account.   2️⃣ Entry Type = Negative Adjustment, This is Used for Reducing Stock-Items from Particular Location/Warehouse/Store.  OR,  You may show Decreased Inventory Values into the Inventory Adjustment Account.   3️⃣ If you Remove Values from Direct Unit Cost or Unit Amount field, System will Not Update Value Entry.   4️⃣ Value Entry, will Update the related G/Ls Accounts into your ERP System.   5️⃣ Posting Date (field) plays a Very Important Role, in the Item Journal (Document/Page/Screen).  ➡️Try to Test in a Demo Company, and then Post it into Live.  ---------------------------------------------------------------------------

Transcript

00:00Hello friends, welcome to my channel, I am Financial Madhvi, and as you can see on the

00:11screen, the item journal page is open and normally you all know the use of item journal.

00:19So the purpose of today's video is that when you create an item journal and when you create

00:28a line on the document, when you choose a posting date, when you choose an entry type,

00:38when you choose a document number, item number and locations and quantity, if you create

00:44all these things on the system and before posting the document, you want to know how

00:53the entries are being created, after posting on which ledgers it will be posted, we can

00:59see the entry before posting it, so what you should do is, click on the small drop down

01:07box on the side of the post button, see related actions for post, and you have to click on

01:14preview posting instead of post, review the different types of entries that will be created

01:20when you post the document or journal, shortcut is ctrl-alt-f9 and it is not posting the document,

01:27it will first preview the entries that are going on these tables, related entries will

01:33be created, jail entry will go on the table, two entries will go, means you will get two

01:39lines, one debit and one credit, item ledger entries will be single line and value ledger

01:46entries will be single line, value ledger entries will represent the value of the item

01:53ledger entries, item ledger entries and value ledger entries, if you have a positive adjustment,

02:00then like a receiving document, physical entry, item ledger entry quantity and value entry

02:10will represent the value of the item ledger entry, but the jail entry will hit the item

02:17hit in the ledger, so let's check the jail first, now like item adjustment, the laser

02:26that is made, you can see it because it is coming on the highlighted screen, once you

02:32click above, you will see the laser on the first line, positive adjustment means that

02:38we are not using sales order, purchase order, we are just updating the stock on our system

02:47using the item journal and if my stock is updated, then which laser will it hit, so

02:55the stock inventory item will have a value, what will be those values, how much quantity

03:02will be there and quantity into rate equal to value will be generated, so seeing all these

03:07prospects, a client will create a jail entry and the laser number of the jail entry, see

03:14through the system setup, it will be installed on the inventory posting setup, it is going

03:19to the group of finished goods in your balance sheet and laser number is 2110, you can go

03:26from here by clicking and it is generating its cost, its debit amount and its credit

03:33amount, the line that is being made for the credit amount system, the credit amount is

03:39going to the inventory adjustment ledger, that is, the finished goods are getting debited

03:45and what is getting credited, inventory adjustment journal, so the positive adjustment that we

03:53use is to update any stock on the system without using any received document, which

04:01you create an order by creating a purchase order, so if you note the goods received,

04:08then data comes on your system, the correct process is that you raise a purchase order,

04:13you make a purchase receipt document, the stock is updated on the system, but if you

04:20had any stock closing and you are bringing freshness in your system, then by using the

04:27item journal, you are updating the closing stock in the system as an opening stock or

04:34if you are updating a stock on a particular location, then what you can do is by using

04:41positive adjustment, you can post this entry, it will hit your two lasers, like I chose

04:47the finished goods, so it is going to the group of finished goods and the second laser

04:52is the credit laser, that is of inventory adjustment, so positive adjustment means increase

04:59inventory item in your stock, so in this way you can increase the stock item in your system

05:11with the quantity and the value, so to check the quantity, you have to check the item laser

05:17entry, the status of the physical quantity update is carried by ILE, it is 10 quantity,

05:25invoice will also be the same quantity, okay, and after that actual value, actual value

05:34because it is directly hitting the GL entries, it will actually update your stock value, so

05:41you always have to check the cost amount actual, that is, its value will be posted in GL entry

05:48and it is carrying this value, quantity comes in ILE and is carried and in the value entry

05:56based on the quantity of ILE, the value that is made by multiplying with its rate, that

06:03value is updated on value entries, see item laser entry type positive adjustment, that

06:11is, value laser entry is connected to your item laser entry and carrying the reference

06:18value, taking the quantity of that item, multiplying it with its direct unit cost,

06:25it creates an actual cost amount, due to which it is called value entry, so value entry is

06:33done, its name is perfect and this value entry is running with the value of 10 quantity,

06:40plus one quantity, which is per unit cost, that is, the value represented here is 1448

06:48and whatever you have taken in decimal prices, you can take it on general laser setup and

06:54in this way, while carrying it, this value will update, ILE base will be of value entry

07:03and value entry base will be made for GL entry, so in GL entry you will get those values,

07:10which you see in the actual amount while carrying the value entry, in this way it creates these

07:17values, plus in which laser it will go, it depends on your setup and item card, which

07:25item card you have taken, how you have designed the setup and posting preview, which

07:32is going to hit on this table, after checking this, what we will do, after checking this,

07:37we can post this entry, as soon as you post, you can also post and print, you will get

07:44print, as soon as you post, these entries will be posted at those places, whose preview

07:50we have just checked, so I am not posting, I am just showing you the preview, that after

07:55posting on these tables, values will be hit, so you post and check,

Item journal - Preview Posting in Business Central

Category

Transcript

Recommended