User

Patrice Vigier

Member since
Total activity 52
Last activity
Following 0 users
Followed by 0 users
Votes 3
Subscriptions 16

Posts

Recent activity by Patrice Vigier

  • UFFI IMPORT ORDERS Sample code

    I looked on this forum to find code to import orders into SAP B1 but I did not find it, so here is what I have done. I hope this help you develop your own code. My code has few commented line, some...

    • 2 followers
    • 0 comments
    • 0 votes

  • Line Loop - select active row - in order form - SAP HANA

    Hello, I want in Line Loop, for an order, only select active row do you know how to do this ? My hana sql would be SELECT T1."LineStatus" FROM "ORDR" T0 INNER JOIN "RDR1" T1 ON T0."DocEntry" = T1."...

    • Edited
    • 2 followers
    • 6 comments
    • 0 votes
    • Answered

  • Add Serial number support in Picklist Crystal Report for B1 Print and Delivery

    Hello, We are using the standard Crystal reports form delivered with SAP B1 9.2 to print Picking list that includes serial numbers. This form is VERY slow, more than 4 second per line. This means t...

    • 3 followers
    • 8 comments
    • 0 votes
    • Answered

  • Cancel a macro

    Hello, Is it possible to cancel a macro for exemple : IF(A=B)BEGIN    Do somethigENDELSEBEGIN      Cancel the macro and return to whatever fired it do not continue the macroEND Other macro commands...

    • 2 followers
    • 2 comments
    • 1 vote
    • Answered

  • Preview text field with html tags

    Hello, It would be great to have the possibility to preview a large text field that is written with html tag like it would appear in a web page.Text field with html tags: Would be shown: Thank you

    • 3 followers
    • 4 comments
    • 1 vote
    • Not planned

  • Set a fixed picture path that is not databound

    Hello, In the B1up release 2015.09 there is a mention of a New features "Added option to set a fixed picture path that is not databound." I did not find anything in the help and forum.Where can I f...

    • 2 followers
    • 1 comment
    • 0 votes
    • Answered

  • In B1 UP How to get the form number ?

    Hello, I have done a macro to automatically sort Items Properties in Items Master Data form (Properties tab). I want also to sort the same universal function/macro in the Item Properties setup for...

    • 4 followers
    • 6 comments
    • 0 votes
    • Answered

  • SQL statment in items placement tools

    On SAP B1 9.1 Hana On Items master data form:I have a user defined field ( a SubGroup) that I want to be linked with the Item group field, so when you click on the drop down field it proposed value...

    • 2 followers
    • 2 comments
    • 0 votes
    • Answered

  • Open a form in search mod by default

    Hello, I'm looking for a "trick" to open a form in search mode by default instead of add mode. For example if you open "Payment terms setup" the form open in "add" which is "dangerous" Any idea? Th...

    • 6 followers
    • 12 comments
    • 0 votes
    • Answered

  • Multi Button error on B1UP

    SAP 9.1B1UP 2015.1.0.0 I created a multi button with 3 functions (Order/Delivery/Invoice) When the button display on the form it has Order as caption, no problem, but when I click on it I expect th...

    • 2 followers
    • 2 comments
    • 0 votes
    • Answered