JeffWill
Participant
Member since ‎2008 Jan 28

User Statistics

  • 123 Posts
  • 4 Solutions
  • 2 Kudos given
  • 4 Kudos received

User Activity

SAP Business One Updating Volume and Discount Price Lists

2024 Aug 13
I have a client who currently has volume and discount pricing.  The current pricing is at 1K, 2K, 5K, 10K, 50K and 100K.  This is working fine.The problem I have is that they want to update these prices but skip the 2K level so the update file has 1K...

Formatted Search Query Issue

2023 Nov 29
I am trying to setup a FS that computes the square footage (SF) of an item based on the purchase length and width. I created two UDF's on the Item Master one Compute SF which is a simple Yes or No and a UDF to hold the computed SF, this field is a qu...

Adding Contacts to OCPR using DTW

2023 Nov 14
I am trying to ADD contacts to the OCPR table. I have code that gets the LineNum I need to insert a new contact in the table. Instead of creating a new contact it is overwriting an existing contact which is not what I want. In the example below th...

Query to Find the Number Invoices for a single Sales Order

2023 Sep 11
I need a query that tells me how many invoices were created from a single Sales Order. I would like to be able to type in the Sales Order number and have the query tell me there were 1 or 4 AR Invoices created for that Sales Order. I want a number of...

Business One Production Order Variance Alert Query

2023 Aug 07
Our client would like to have an Approval process fire when a user tries to close a Production Order that has a variance. I have looked in the tables and the variance view but I'm not sure how to create a query to analyze it when closing a Production...
View more