former_member288252
Explorer
Member since ‎03-07-2016

User Statistics

  • 19 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

I need help figuring out why the query below doesn't allow me to show T3.BsDocType and T3.BasDocEntry. It shows -1 on both of those - it doesn't seem to make sense. SELECT T0.DocNum, T0.DocDate, T0.CardCode, T0.CardName, T...
I am trying to build a query that will show the batches and their corresponding source goods receipt and purchase order for each delivery document. This is because each PO has a link to a quality document that I want to easily access.I have crafted t...
Hi,I recently noticed that my simple query was not working due. In our business we use AP Reserve Invoices when we import. This results in the Purchase Order line item Open Quantity being reduced to 0. How do we determine accurately what has not yet...
Even SAP B1 9.2 doesn't come with the latest set of Crystal Report Layouts. I did get hold of the 9.0 crystal layouts with the standard SAP branding however. Having experimented with getting a freelancer to produce documentation from scratch, it is c...
This formatted search query to calculate price per kg works if the weight field contains an amount in kg.SELECT CAST($[$38.20.number] AS DECIMAL(18,4)) / ($[$38.58.number] / $[$38.11.number])However, I have discovered that if I change the sales unit ...