we have our stores in factory and accounts department in the head office away from the factory whatever the deliveries we received in the factory, the purchase will be recorded in head office but the GRN will be made in Factory when we are booking purchases and select the inventory item it creat the duplicate entry in inventory.
I am not sure what @Ealfardan is referring to when discussing sales and purchases between entities. Based on your question, @WAQASKHAN, you seemed to be asking only about parts of your operation being located in physically separate places. As long as you are using either the server or cloud edition of Manager, personnel at both locations can be set up as users with relevant permissions. Then, there is only the question of proper management supervision to be sure everyone follows the established procedures.
If you are asking about something different, please explain.
Actually, I am thinking of this as a three-way matching concept but in Manager it is not, for example, we received any raw material in the factory against a LPO on the basis of LPO and GRN we can book a purchase Invoice. this a three-way matching but in the manager when we create a GRN and after that invoice the inventory becomes double. this is the problem I am facing right now.
and I don’t want to share LPO and invoice details with my stores what should I do.
Thank you.
Are you copying the goods receipt to a purchase invoice? That preserves the relationship between them. Or are you creating a new purchase invoice, which would tell the program you are buying additional material?
Don’t give those users access under User Permissions.
Seeing the drill-down on the quantity on hand for this inventory item, I suspect you entered a purchase invoice before you enabled the Goods Receipts tab. That would have added 1,000 units to your inventory. Then, I believe you enabled the Goods Receipts tab. At that point, if items are purchased via purchase invoice, they are added to inventory only when a goods receipt is created. So it looks like you have mixed two workflows for one purchase.
No from the very beginning, I am using the Goods receipt tab, let me explain for you step by step, and then you please help me where I am wrong.
Step 1 we received material and generate a goods receipt note which increases the stock level.
Step 2 With the copying Method we create a purchase invoice.
when we create a purchase invoice it increases the stock level with the same quanity.
Yes, that is what I meant. If the Goods Receipt tab is enabled from the beginning, no transaction shows up in that drill-down for the purchase invoice. Only the goods receipt changes the quantity.