In this blog post, we wanted to share little tips and tricks that we here in support have picked up and want to pass on to you.
How do I Get Real Time Posting in Inventory Control
The only way to have real time posting to work is if in IC options, under the Costing Tab, Cost Items During and Create Subledge Transactions and Audit Info. During is both set to Posting.
Real-time posting is useful in Order Entry, General Ledge and Accounts Receivable, especially if one person is doing all three roles but we normally don’t recommend doing real time posting especially in Accounts Payable.
If you set Costing to be done during posting, remember that these settings have a large impact on how Sage 300 ERP handles inventory transactions. They apply to all inventory transactions created in Inventory Control, Order Entry, and Purchase Orders.
If you cost inventory during posting, then sales order posting and purchase order posting will take longer.
Also, if you create sub-ledger batches during posting, you may also create and post A/R invoice batches with each O/E invoice and A/P invoice batches with each purchase order invoice.
After setup, you can switch from costing during posting to costing during day end processing at any time. However, you must run Day End Processing before switching to costing during posting to make sure that you complete item costing and to make sure that all G/L transactions have been created properly.
Why do deleted batches keep appearing in GL?
Sage 300 ERP creates a batch to see if a Journal Entry is needed in GL. If it is not, the program will delete the batch. 
Normally, this applies to non-stock items. Non stock items don’t require a journal entry in GL.
However, seeing deleted batches in your GL Batch List clutters it. To de-clutter, in Order Entry Setup, go to GL Integration and change Create GL Transactions to from During Posting to On Request Using Create Batch Icon.
Adding New Accounts
Normally people would click the new button but if adding an account with similar values like account number, just add the appropriate segment to the end and not click new.
Ex: 6385 then instead of clicking new, just add 6385-01
Macros
You are probably wondering what is this, well the Macros area is where you find the Budget Excel file.
What this does is it can pull accounts into this Excel spreadsheet.
You find this by following this navigation path: Program Files>Sage>Sage 300 ERP>Macros then click on Budget.xls.
When you open the file, hit the Retrieve Budget.
Enter your credentials and the database ID.
Enter the appropriate fiscal year and the accounts.
This is a quick and easy way to get the budget in Excel that allows you to Excel to calculate budget amounts.
Also, you can export the budget back to Sage 300 ERP and it should be reflected back in budget maintenance.
“You don’t have a license to use this product”
This workaround applies if you see this error when opening up a company on a specific computer or with a specific Windows user.
First thing you need to do is verify where Sage 300 ERP is looking for the shared data directory by checking the registry. Go to Start, Run then type in regedit.
Then follow this navigation path: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ACCPAC International, Inc.\ACCPAC\Configuration
Next go to Shared Data. When you are here see if the Shared Data is accessible. Users must have full access to the folders and sub-folders. We recommend the users be Power Users.
Also, double click on Shared Data and then copy the Value Data.
Then paste it in Start. You should be able to see the license files. If you get an error, then just paste it in your browser’s address bar.
Got any other Sage 300 ERP tips and tricks you want to share? Sound off in the comments.
