• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Recent content by MarshallB

  1. M

    Table I/O insert being skipped

    Saying it out loud (typing it out loud?) was the key! My statement above was not entirely true, I had added the time + 1 variable, but I had not removed the fetch for time, so I was still causing the duplicate key error. Cleaned it up and it now works. Thanks for the suggestions. Marshall
  2. M

    Table I/O insert being skipped

    Good catch, it did originally until i figured out no time had elapsed. So now my key is doco, date, and time + one. So i get the time once, on the first statement, then in each subsequent call I take my time variable +1. As to where this is being called. First call is on the submit order...
  3. M

    Table I/O insert being skipped

    Hi All, I have a scenario where I'm trying to log some events/data from the P42101. I created a small custom table, and within the ER of the submit order button and another, custom button, I have several Table I/O inserts into my custom table. However, only one or two of the inserts are...
  4. M

    Setting up Discounts at item level.

    Hello, Are you using advanced pricing? You mention order level discounts, so I'm assuming so. If so, you can just create a line level adjustment in your pricing schedule. You setup which items get the adjustment in item branch Item Price group field, and setup your advanced pricing...
  5. M

    Retrieve Session Key (SNKY)

    Thanks for the detailed response, that helps give me a better understanding. As for my particular use case, the session key will already exist. I'm using an advanced pricing basis code 8 function (which allows you to call a custom business function from advanced pricing to manipulate prices)...
  6. M

    Retrieve Session Key (SNKY)

    Hi all, Is there a business function I can use to retrieve session key? I have an advanced pricing basis code 8 function, in which I would like to edit the SO header cache. There are Business Functions I can use to affect the SO header, but I need to pass in session key. I should add...
  7. M

    Maintain Customer Specific Inventory

    Thanks for the reply, On the stocking in different packaging point, I think we will stock it in different packaging. Currently thats still up for debate, but most are leaning towards stocking this way. Marshall
  8. M

    Maintain Customer Specific Inventory

    We're looking at options to segregate inventory for a customer. We've rolled around lots of options including; a new item number that we only sell to them; Lot controlling this item number; Using an inventory commitment preference and creating a new branch. Each of these comes with its own set...
  9. M

    Setting Warning Message P42101

    Great, glad you were able to get it to work. Marshall
  10. M

    Basis Code 8 function and Error Handling

    Hello all, I'm using an advanced pricing Basis Code 8 adjustment to enforce UOM during order entry. My function is pretty simple, it checks the UOM, then based on the condition will throw an error; jdeErrorSet(lpBhvrCom, lpVoid, (ID) 0, (PJSTR)_J("141WIM"),(LPVOID)NULL); return ER_ERROR...
  11. M

    Setting Warning Message P42101

    Hi Ed, In order for this to work you'll need to add your new field to the data structure for the P421002 and then on the P42101, add that field in the mapping link. Then, from your subform you need to tell the parent the value of that field. From the mapping link you'll have SI variables, you...
  12. M

    Setting Warning Message P42101

    Hello, This will be quite deep, and perhaps you've already accounted for this, but I can't tell from the post. In order for the field you've added to the grid to actually make its way to the database, and/or error handlers you'll have to add it to the data structure/mapping link, and into the...
  13. M

    sales order next numbers

    Hello, You associate a next number with a line type in your order activity rules. In your activity rules setup screen there is an order type next number, that is the number of the next number range you want to use. So for example in your system 42 next numbers, the first one you've setup is 1...
  14. M

    Calling UBE from NER print immediate

    Thanks for the reply Peter, We have that .ini setting. This disappearing act is new with the roll out of the NER. That same UBE when called from BV will print immediate and stay in submitted jobs, but when called from the NER it disappears. We did find an oracle document yesterday that seems...
  15. M

    Calling UBE from NER print immediate

    Hi All, I created a very simple NER to call a UBE from an interactive, so as not to show the printer selection screen. There are lots of posts about this functionality, but there is a small wrinkle. If the UBE that I call is checked to print immediate (in report versions settings), it does...
Top