Sage 300 2014 (62A)
Is there an easy way to reverse a posted AR Invoice? Our users create credit note but still very manually and we usually have very big invoices with numerous lines. Even if there is a way to have a credit note automatically filled out from an existing invoice, it would help a...
Sage 300 2014 (62A)
We have an old un-receipted PO that we need to close, either by changing its Quantity Outstanding to 0 or doing a 0 receipt and still marking it as completed. The line is for a non-stock item which may have been a stock item when the PO was created.
When we try closing the...
Well that's kinda bizarre... so basically Sage just expects all users to manage the macros and custom reports themselves. Then if we reorganize and move the macros, it will be a pain to update the users' shortcuts. Any tips or tricks to help ease the process are greatly appreciated!
We are currently on Sage 300 2014 (62A) and are looking for a way to clean up and reorganize all the custom macros and reports. Is there any way to "see" from an administrator's point of view which custom macros and reports shortcuts as well as their path that each user has? I figured it could...
We have over 40 databases on different servers, and some servers are in remote locations where connection is not great.
Anyway, the system database was the key. There is another CSCRT table in the system DB.
Thanks!
Sage 300 2014 (62A)
We need to add a new currency rate type for several databases. We have a script to deploy an SQL script to all of our databases. So I tried to make that SQL script an Insert statement to the CSCRT table.
Running the INSERT statement on a test database did insert the record...
OK this may be a long shot but is there a way to query an item in inventory (joining different tables) to get how many on hand and what makes up that amount?
For example:
Item ABC, 50 on hand total $5200, made up of:
- 20 at $100 from RCP100
- 20 at $105 from RCP101
- 10 at $110 from RCP102
So whenever the inventory comes out (shipment, transfer from, receipt return, etc.) the system always checks and uses the offset bucket in ICILOC first? Or are there exceptions depending on the type of IC transactions?
We are running Sage 300 2014 (62A) and have been trying to work out how Sage deals with FIFO. Specifically, how does it determine which item (at which cost) to cost first when consumed?
It would help tremendously if someone could help with the logic behind the whole thing, especially how to link...
I checked the working ones and my test ones as well. They all show on the PO Invoice Posting Journal, either as the difference or just O if there's no difference. And there's no third-party application for this process. I figured this must be a bug since the only scenario where it doesn't show...
Yes I did multiple tests in our test database and anytime I invoice a receipt and change both the quantity and unit cost that results in the same extended amount (like RCP2), that line won't show up in the PO Invoice Posting Journal. Any other case (invoice same as receipt, change just quantity...
We are using Internal Issues 62A and our users notice that fairly often, when they run Create Issues from Reqs, some items on the same Req will create multiple II's, and other times just one II.
I looked into these II's and so far I could not make any connection between those. They seem random...
We have 2 PO Receipts, RCP1 and RCP2. One PO Invoice was done on both receipts (checked off Multiple Receipts) but:
- RCP1: invoiced exactly the same with the rcp
- RCP2: received 2 items @ $100, but invoiced 1 item @ $200, Fully Invoiced marked Yes
I queried from table POINVAH / POINVAL to get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.