UPDATE STOCK QUANTITY AFTER INPUT ERROR

[Former Member]

Dear All,

We just started using SAP B1 in my organization so you have to consider that I am a rather inexperienced user!

By mistake our logistics department made a wrong input in the quantity of an item. As a procurement manager, I have been assigned a professional user license and I can correct this mistake, but I don't know how!

Thank you all in advance.

Nassos.

[former_member392937 · Accepted solution]

Hello Nassos,

Welcome to SAP B1 forum.

Before using the Goods issue and Goods receipt transactions you have to notice that you don't use perpetual inventory in your system but non perpetual.

(Previous Nagarajan K post: "In a non perpetual inventory system, sales, purchasing, inventory, and production transactions, which reflect the inventory value, do not generate inventory related monetary entries directly into the general ledger. Therefore, the inventory value of a company is not revalued on every inventory release or receipt. Instead, the inventory balance is updated once every accounting period or after a physical inventory count.")

So you have to look very good the dates for the transactions. Financial Laws in Greece are very strict for these transactions and you have to be sure with your accountant that you will be ok at any audit.

I guess that you have to use the last day of the usage of the old system (before migrating to SAP) to post these transactions.

With regards,

HK

[kothandaraman_nagarajan]

Hi,

Welcome to SAP B1 forum.

Use Good issue transaction (under inventory--->Inventory transaction--> Goods issue) to reduce stock of the item.

Add required notes at remarks for your reference.

Thanks & Regards,

Nagarajan

[former_member184146]

Hi Nassos,

Welcome to the B1 Community , can you tell which entry you have posted wrongly i.e. GRPO or Goods Receipts??

If it is GRPO  : you can do the Goods Return document & repeat the the Procurement process with correct quantity.

if it is Goods Receipts   : then Make a goods issue for the same item & quantity , Price & repeat again the Goods Receipts with correct quantity.

--Manish

[Former Member]

Thank you Manish for the reply.

This time refers to a Goods Receipt, what you mean by "a goods issue"?

Moreover, apart from this, there are cases that stock quantities were migrated wrongly by our previous system (not a SAP). This migration was carried out by the company that installed B1. However, now they're gone and I have to fix that too. So, what happens in this case? The wrong entries of items occurred during the installation/customizing process.

thanks again.

Nassos.