Dear Experts,
Scenario:
My client buys poles in different lengths: 4 feet, 8 feet, 16 feet, 25 feet.They use these poles in production. They can cut up the longer poles into shorter lengths required in manufacturing. They cannot put together sho...
Dear Experts,
We are using the SAP Hosted B1 on Hana. I'm able to login with this user, but he cannot login from his workstation as the Windows Security credentials window keeps on popping up, not allowing him to access B1.
Steps to login:
1. U...
Dear Experts,
I have a customer with the following question: They post an AR Invoice to Customer A with 300-3000 lines (each representing a patient). When payment is received from Customer A, they would like to allocate that payment to specific lin...
Dear Experts,
My client (SAP B1 Hana) needs to have the Sales Quote Crystal report line number suppressed when it is a text line. What makes this a challenge is that the subsequent item line needs to follow the line sequence.
Example:
001 - Ite...
Dear Experts,
I have this query that uses SQL syntax that I need to convert to Hana syntax. Your assistance would be very helpful.
Thank you!
Marli
SELECT CAST(T1.trgtPath AS nvarchar(4000)) + '\' + T1.FileName + '.' + T1.FileExt FROM ORDR T0...
Johan,Thank you! This is worth giving it a shot.Do you know if there are any standard inventory reports that will show the qty of the UoM groups separately/split up? I could not find one, and this will be a deal breaker.Thank you,Marli Schutte
Dear Sundararaja,I did test this with $0 Standard Cost, but when ever I try a Delivery, I get the error "Item Cost not Found".I also get this error on a Inventory Transfer.Regards,Marli
Dear Sundararaja,I was hoping to see Inventory quantities move without it hitting the GL.Here is an example of what we would like to accomplish:PO < Goods Receipt (No JE). Close Goods Receipt (No JE) - We want to utilize PO's and Goods Receipts to sh...
Dear Hrvoje,Thank you for the Insight. I will change this to 'Per Warehouse' and test again.BUT the Inventory Transfer that I did, were for an Item that had 0 qty in ALL the Warehouses. Please see screenshot attached.Regards,Marlineg-inv.png
