Knowledge Base: Inventory Module

Manages your inventory, including warehouse inventory, price lists, special pricing agreements, alternative items, and warehouse transactions, as well as the pricing and packaging process, and batches and serial number management.

Inventory Audit Report Does Not Match GL Account Balance

At some point working with SAP Business One you are going to get a question about GL account balances not matching the inventory audit report. Generally this is related to the year-end-closing process. Unlike accounts receivable and accounts payable, inventory…

Posted by: Michael Taylor

Exporting SAP Business One Data to Excel

As you can imagine, the ability to export data to Microsoft Excel directly from the SAP Business One client is a powerful tool. This can be used to get a good look at the data, run further summaries and calculations, and can even be used to import the data back into SAP B1 using the Data Transfer Wizard.

Posted by: Peter Canale

Purchase Request Marketing Document – Purchasing Process

The purchase request document in SAP Business One can be used as the preliminary step in the entire purchasing process. It allows users to initiate the purchasing process by submitting their needs.

Posted by: Peter Canale

Change Log on Marketing Documents in SAP Business One

There are many times when troubleshooting customer service or procedural issues you need to know "who did what" on a marketing document or master data. This is where the change log comes in to play. The change log will show you exactly who changed a document and answers many of the important questions.

Posted by: Peter Canale

Inventory Audit Report and Year End Closing SAP B1

Continuing our series on year end closing, comes the Inventory Audit Report. This report is designed to help you reconcile your yearly inventory transactions with the ending balance in your inventory G/L account balances. The inventory audit report will give you the total inventory value for the criteria you've selected.

Posted by: Peter Canale

Relationship Map Overview for Marketing Documents

The relationship map is a graphical display of the base document and target document tree, posting details, or the master data involved with the marketing document. It is useful for getting the whole picture of a process where you are starting with just one piece of information, like a sales order number.

Posted by: Peter Canale