Search results for query: *

Hi! I added pwformatdate and it worked!! thank you so much. whilePrintingRecords; Local StringVar a := ToText(pwformatdate({ARRFH.DOCDATE}),'MM dd yyyy'); Local Numbervar b :=Len(a); Local Numbervar i; Local Stringvar RESULT := ' '; for i := 1 to b Step 1 do RESULT := RESULT + mid(a, i,1) +...

Hi! with error "bad number format string". then this was highlited. whilePrintingRecords; Local StringVar a := [highlight #FCE94F]ToText({ARRFH.DOCDATE},'MM dd yyyy');[/highlight] Local Numbervar b :=Len(a); Local Numbervar i; Local Stringvar RESULT := ' '; for i := 1 to b Step 1 do RESULT...

Hi! I'm using the date format 12 31 2022. No separator. How am I going to put space between month, day and year in digits? Example, 1 2 3 1 2 0 2 2. Thank you.

Good day! How can I show original document date for this report? I am trying to show all payments under a particular invoice. My tables are ARCUS, AROBL and AROBP. Thank you. SI-0001 1/2/2019 30,000.00 OR-0001 1/18/2019 (25,000.00) CN-0101 *** (...

By the way, we are using Accpac 5.4A. Thank you.

Good day! what to do when opening vendor activity and you cannot see list of vendor in finder? But if you type the vendor code, the activities of that vendor will appear? Thank you.

Hi. What does this error means when opening table in UI info: "Failed to create object. Make sure the object is entered in the system registry" Thanks.

Yes. We can have more than 1000 gaps in document no. Yes I am finished with my report now thanks to you.[smile2]

It's working. I just need to change my parameter so I won't encounter missing series more than 100. Thank you so much!

There's an error. "An array's dimension must be an integer between 1 and 1000" Then this part is highlighted: redim preserve x[i];

I need to see the missing numbers of the alpha numeric series. Document number differs every branch so it can be various letters and numbers. There can be 2 to 4 letters separated by 4 to 6 numbers. Example: ABC-00200 ABC-00201 ABC-00202 DC-4568 DC-4569 DC-4570 ZB-001210 ZB-001211 ZB-001212...

Yes its working. For example, ARIBH.IDINV is a string. We manually enter alphanumeric document number like SI-0001, SI-0002 ... . Can you also identify missing series here? Thanks.

[bigsmile] No. I thought its for 6/29 formula only. [bigsmile] Can you do this on strings? Like your series is alphanumeric? Thank you so much. I'm finished with my report.

Do I still need your first post in July 3? I forgot to tell you that unbound was highlighted and there was an error saying "A number, currency amount, Boolean, date,time, or string is expected here". {@check no 2} is tonumber({APPJH.IDRMIT}) I cannot put everything in details section. Data...

There's no more blank series. Below is my formula for missing series. I placed it in GFb then suppress section if blank. My report is grouped by APPJH.IDRMIT. My fields in section GFa are APPYM.DATERMIT, your most recent formula, APPYM.TEXTPAYOR, APPJH.TEXTREF, APPYM.AMTPAYM and...

The formula returns the last series blank. This what my report looks like: 5447649 is the missing series. The formula returns it together with the series before it. date check no 5/12/17 5447647 5/12/17 5447648 5447648 5447649 5/15/17 5447650 5/15/17 5447651 5/17/17 5447652 5/17/17...

I changed my parameter. The message still appears on a particular page and if I click on next page it goes back to page 1. I prefer your recent formula. thanks.

Uhm.. Don't mind my last post. I tried your recent formula and no message appeared but it also shows the number before the missing number so it appears twice in the report.

In your earlier formula, this message appears in my report? "An array's dimension must be an integer between 1 and 1000." Then if I close it, this part of formula is highlighted. redim preserve x[i]

I just want the missing series in the same column with the existing series even if its the only field in the row.