The return to bkper

[Administrator Lagaroo]

Hi!

I am making a time sheet invoice with bkper as the origin of registration. 

I followed your timesheets example and once I generated the invoice I want to return this fact as a transaction to bkper. 

The thing is that the "record transaction" does not seem to work for a batch of lines and I do not know how to repeat the form 

as many times as lines in my spreadsheet. 

  If I use the ${4trevor.debit} variables the transaction is not launched on bkper. 

  Any Tip on how I can post a return to bkper for each of the lines in my invoice?

  Maybe it is handy to show that the idea is to do the same as in this video by just using the bkper and ultradox add-ons and no lines of Apps Script.

Cheers 

Jacob

[Mael Caldas]

Did you ensure the ledgerId corresponds to the correct ledger you are trying to post?

If you share the Ultradoc, and the corresponding ledger, with me (ma...@nimbustecnologia.com.br), , maybe I can help better.

Cheers,

Mael

[Daniel Florey]

Right now there is no "Loop" block in Ultradox which would allow you to record a bkper transaction for each row in your timesheet.

You have 3 options:

- Create a new Ultradoc that leverages the "Load row(s)" block to create the transactions in bkper, then call this script for each line either from the UI or from a Google Apps Script

- Ask the bkper guys if they are able to adopt the script so that it takes a list of values as an input

- You'll have to wait until such a block is available

Hope this helps,

Daniel

[Mael Caldas]

Bkper allow to record batch transactions, separated by break lines "\n". 

Daniel, is there any way to send the text with break lines?

--
You received this message because you are subscribed to a topic in the Google Groups "floreysoft" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/floreysoft/KxJE3a3y8DI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+...@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

--

Mael Caldas
Co-founder & CEO of bkper
http://about.bkper.com

+55 31 9681 8639

[Mael Caldas]

Also, the BkperApp is supposed to allow a array of text, or a matrix as its parameters to record. Each text line, or matrix row generates one transaction

[Daniel Florey]

That's pretty cool!

Yes, you can then use a foreach loop in the form field that populates the script to generate the required input. Something like this should do the trick:

${foreach 4trevor row}${row.debug} Open invoice ${row.account}\n${end}

To unsubscribe from this group and all its topics, send an email to floreysoft+unsubscribe@googlegroups.com.

To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

[Administrator Lagaroo]

Okay almost there... 

It seems that in the text input field even with the foreach it just posts one post.. not a batch!

So I have this in the input 

   

 ${foreach 4trevor row}${row.debug}   ${row.debit}  Open invoice ${row.account}  #opened ${row.description}'/n' ${end}

And the result is this 

I have tried /n ,  '/n' , \n and '\n' but the result is the same. 

To unsubscribe from this group and all its topics, send an email to floreysoft+...@googlegroups.com.

To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

[Mael Caldas]

Daniel,

We are trying in 2 different ways:

1) By passing the text with \n separator. The text is arriving in the script without the slash, that is, only with "n" instead of "\n", so its recording as one single transaction, instead of batch.

2) I've added to the Record Transaction script another input parameter, of type LIST, called "items". When executed, it supposed to record the list of items in bkper, with each item generating one transaction each, but I'm not able to load the data from the spreadsheet, transform in an array of items, and send it to the script. Any clue?

I've created an simple Ultradoc test it and shered with you:

http://www.ultradox.com/file/0B8GmHJLN7S31ZmJuUVZxMk9iUms

Thanks in advance!

[Daniel Florey]

Looks like an issue on our end... I'll check tomorrow and will let you know.

Thanks+cheers!

Daniel

--
You received this message because you are subscribed to the Google Groups "floreysoft" group.
To unsubscribe from this group and stop receiving emails from it, send an email to floreysoft+...@googlegroups.com.

[Mael Caldas]

It's working now! Thanks to Daniel's help!

Here is what was missing:

The input type must be Text, not String, to accept break lines.

The break line must be a carriage return, and not a \n, like this:

${foreach 4trevor row}${row.debug} ${row.debit} Open invoice ${row.account} #opened ${row.description}

${end}

Be aware the breakline (by carriage return and not \n special char) before the ${end}

Cheers!